Tabela FKMappingRule

Definicja tabeli FKMappingRule

Name

FKMappingRule

Code

FKMappingRule

Comment

Tabela regul mapujacych dla importu z modulów FK


Lista kolumn tabeli FKMappingRule

Name

Code

FKMappingRuleID

FKMappingRuleID

CostAccountID

CostAccountID

AccountID

AccountID

Pattern

Pattern

CompareOptionID

CompareOptionID

Active

Active

StartDT

StartDT

StopDT

StopDT

SequenceNo

SequenceNo


Kolumna FKMappingRuleID tabeli FKMappingRule

Definicja kolumny FKMappingRuleID tabeli FKMappingRule

Name

FKMappingRuleID

Code

FKMappingRuleID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Identyfikator reguly


Kolumna CostAccountID tabeli FKMappingRule

Definicja kolumny CostAccountID tabeli FKMappingRule

Name

CostAccountID

Code

CostAccountID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Identyfikator osrodka kosztów


Kolumna AccountID tabeli FKMappingRule

Definicja kolumny AccountID tabeli FKMappingRule

Name

AccountID

Code

AccountID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Indentyfikator rodzaju kosztów


Kolumna Pattern tabeli FKMappingRule

Definicja kolumny Pattern tabeli FKMappingRule

Name

Pattern

Code

Pattern

Data Type

VARCHAR2(128)

Mandatory

No

Comment

Wzorzec reguly


Kolumna CompareOptionID tabeli FKMappingRule

Definicja kolumny CompareOptionID tabeli FKMappingRule

Name

CompareOptionID

Code

CompareOptionID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

Sposób porównywania


Kolumna Active tabeli FKMappingRule

Definicja kolumny Active tabeli FKMappingRule

Name

Active

Code

Active

Data Type

NUMBER(1)

Mandatory

Yes

Comment

 


Kolumna StartDT tabeli FKMappingRule

Definicja kolumny StartDT tabeli FKMappingRule

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

Data poczatku obowiazywania


Kolumna StopDT tabeli FKMappingRule

Definicja kolumny StopDT tabeli FKMappingRule

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

Data konca obowiazywania


Kolumna SequenceNo tabeli FKMappingRule

Definicja kolumny SequenceNo tabeli FKMappingRule

Name

SequenceNo

Code

SequenceNo

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Lista kluczy tabeli FKMappingRule

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli FKMappingRule

Definicja klucza Identifier_1 tabeli FKMappingRule

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment